﻿        public bool ShowTranscript(string fromDate, string toDate ,ref DataTable dt)
        {

            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@fromDateOfBill", SqlDbType.NVarChar, 50);
            param[0].Value = fromDate;

            param[1] = new SqlParameter("@toDateOfBill", SqlDbType.NVarChar, 50);
            param[1].Value = toDate;
            dt =SelectTable("Transcript", param);
            if (dt.Rows.Count > 0)
                return true;
            else
                return false;

        }
